CREATE NONCLUSTERED INDEX idx_issue_sales_key ON performance.issue_sale(issue_sales_key);
CREATE NONCLUSTERED INDEX idx_dpr_date ON performance.issue_sale(dpr_date);

CREATE NONCLUSTERED INDEX idx_issue_sales_key ON performance.sales_map(issue_sales_key);
CREATE NONCLUSTERED INDEX idx_submit_sales_key ON performance.sales_map(submit_sales_key);
CREATE NONCLUSTERED INDEX idx_submit_sales_sub_key ON performance.sales_map(submit_sales_sub_key);


CREATE NONCLUSTERED INDEX idx_submit_sales_key ON performance.submit_sale(submit_sales_key);
CREATE NONCLUSTERED INDEX idx_submit_sales_sub_key ON performance.submit_sale(submit_sales_sub_key);
CREATE NONCLUSTERED INDEX idx_agent_code ON performance.submit_sale(agent_code);
CREATE NONCLUSTERED INDEX idx_submit_date_time ON performance.submit_sale(submit_date_time);
CREATE NONCLUSTERED INDEX idx_contract_num ON performance.submit_sale(contract_num);
GO